﻿CREATE PROCEDURE [dbo].[Hogar_Actividad_ObtenerHorarios]   
 @ActividadId INT
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener los horarios de una actividad
-- Returns:    HorarioActividad
/*****************************************************************************************************************************************/ 
	
	SELECT  [ActividadId],
			[DiaSemanaId],
			ISNULL([HoraComienzo],'') AS [HoraComienzo],
			ISNULL([HoraFin],'') AS [HoraFin]
	FROM	[dbo].[HorarioActividad] WITH (NOLOCK)
	WHERE [ActividadId] = @ActividadId
	ORDER BY [DiaSemanaId]
	
END